{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Introduction and guidance","Flock input details","Diet input details","Results","References and assumptions log","Calculations - Data tables","Calculations - Dataset"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":2,"defined_names":8,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction and guidance","index":0,"n_rows":79,"n_cols":33,"rows_kept":79,"cut":false,"hidden":false,"merged":[[35,2,35,14],[36,2,37,14],[41,2,42,12],[41,13,42,15],[43,2,63,14],[38,2,38,14],[39,2,39,14],[40,2,40,3],[40,4,40,6],[40,7,40,9],[40,10,40,12],[33,2,33,4],[33,5,33,6],[34,2,34,4],[34,5,34,6],[33,7,33,14],[34,7,34,14],[9,2,12,14],[14,2,15,14],[16,2,17,14],[18,2,31,14],[32,2,32,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Duck excreta mass balance model"]
[]
[]
[]
[]
[null,null,"Nutritional Management Best Available Techniques for Poultry \n(click here to see regulations)"]
[]
[null,null,"Best Available Techniques (BAT) Reference Document for the Intensive Rearing of Poultry or Pigs \n(click here to see reference document)"]
[]
[null,null,"\nIntroduction:\n\nFarms with more than 40,000 rearing places for poultry fall in scope of regulations requiring the adoption of Best Available Techniques (BAT) to reduce environmental emissions. BAT for pig and poultry farms is outlined in a published BAT Conclusions (BATC) document (see link above). BAT 3 requires farms to reduce total nitrogen excreted.  The  BATC include levels for total nitrogen excreted, measured per animal place. All permitted farms must meet these levels.  \n\nBAT 24 requires the monitoring of total nitrogen and total phosphorus excreted with two recognised methods: Calculation by using a mass balance or estimation using manure analysis results.  Issued permits contain conditions requiring submission of the derived data on an annual basis.  \n\nThis simple spreadsheet tool has been designed to assist farms in assessing compliance with the new BAT for duck and follows a mass balance calculation approach. The tool is recognised by the Environment Agency, Natural Resources Wales, Northern Ireland Environment Agency and Scottish Environment Protection Agency.\n\nInstructions:\n\nTo calculate the BAT Emission levels please follow the instructions embedded within each worksheet.  Details of the Flock and Diets need entering in the ‘Flock Input Details’ and ‘Diet Input Details’ worksheets, the emission values and feed intake data will then be calculated in the  ‘Results’ worksheet.  Only when all values are completed within the input forms will the BAT values be calculated. \n\nInputs need to accurately reflect your system usage across the year. You should save a copy of your completed calculator tool in case it is requested as part of future permit compliance checks.\n\nYou will need to read the terms of use below and tick the agree box before you can use the tool.  \n\n\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"BAT Total Nitrogen Excreted Levels"]
[null,null,"Parameter",null,null,"Category",null,"BAT-associated total nitrogen excreted ⁽¹⁾⁽²⁾ \n(kg N excreted/animal place/year)"]
[null,null,"Total nutrient excreted ",null,null,"Duck",null,"0.4-0.8"]
[null,null,"(1) The lower end of the range can be achieved by using a combination of techniques. \n(2) The BAT-associated total nitrogen/phosphorus excreted is not applicable to pullets or breeders, for all poultry species. \nThe associated monitoring is in BAT 24. The BAT-associated nitrogen excreted levels may not be applicable to organic livestock production nor to the rearing of poultry species not indicated above."]
[null,null,"Acknowledgements:\n\nThis simple spreadsheet tool has been designed, based on an update of the previous model (created by AIC), by Ricardo. This work model has been developed on behalf of the Environment Agency alongside a partnership of industry bodies (BPC, BEIC) to assist farms in assessing compliance with the new BAT for poultry. The tool has been reviewed by industry representatives and is recognised by the Environment Agency, Natural Resources Wales, Northern Ireland Environment Agency and Scottish Environment Protection Agency.\n"]
[]
[null,null,"Terms of use"]
[null,null,"Enter your installation name and permit reference number in the white boxes below:"]
[null,null,"Installation Name:",null,null,null,null,"Permit Number:"]
[null,null,"To use the calculator, first read the terms of use below and tick the box to confirm your acceptance \n(the calculator will not work if this box is not ticked)",null,null,null,null,null,null,null,null,null,null,"Tick to confirm\nacceptance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,"Terms of use\n\nIn making use of the BAT Emission Calculator (“the Calculator”), I agree to and accept the following:\n1. I understand that the Calculator has been made available to me by the PARTNERS (Environment Agency, BPC, BEIC) (“the Partners”), and that whilst the Partners have used their best endeavours to ensure the accuracy of the Calculator, the Partners accept no liability or responsibility whatsoever for any errors or omissions in the Calculator.\n2. I understand that, so far as is permitted in law, the Partners accept no liability or responsibility whatsoever for any losses, financial penalties or other consequential losses howsoever arising from my use of the Calculator.\n3. It is my responsibility to ensure that the data that I input into the Calculator is accurate and correct.\n4. I accept that the Partners and their employees and agents do not have sufficient knowledge of my individual farm or business to provide advice as to my individual requirements.\n5. I understand that the Calculator is no substitute for professional advice and that I should seek professional advice as to my compliance requirements under any relevant legislation.\n6. I agree that it is my responsibility to ensure that I comply with the relevant compliance requirements under any relevant legislation.\n7. I agree that English law applies to my use of the Calculator, and the Courts of England and Wales have jurisdiction to hear any disputes arising from my use of the Calculator.\n8. I agree that if I am using the Calculator in a professional capacity for the benefit of a client, it is my responsibility as my client’s professional adviser to advise my client on his / her compliance with the relevant requirements under any relevant legislation."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Please note: If further details on the data inputs and calculations are required, calculation sheets can be unlocked within the model by right clicking the 'Introduction and guidance' tab, clicking 'Unhide...' highlighting each sheet and clicking 'OK'."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]

{"sheet":"Flock input details","index":1,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[3,1,3,2],[9,3,9,4],[25,6,28,12],[2,6,23,12]]}
[null,null,null,null,"Input data - flock details"]
[]
[null,"Flock input table 1:",null,null,null,null,"\nFlock details input instructions\n\nPlease note: One complete workbook needs to be filled out per management system on your farm.  \n\nFlock input table 1:\nEnter number of birds per cycle and number of days between the final clearance and the next cycle in the two white boxes. Note this should reflect the number of birds per cycle not the total annual number of birds. The number of birds per cycle entry cell will go red if the value entered is below 40,000 rearing places, the BAT regulation limit. If you have under 40,000 birds you can still use this tool as normal.\nNote: Number of cycles will not calculate correctly until Flock input table 2 is completed.\n\nFlock input table 2:\nEnter the age of thin(s) to the flock in days and the percentage of birds taken each time in the white boxes. Note, the percentage of thins and clear should total 100%.\nNote: If no thinning occurs, just complete Age of clear and % clear (i.e. 100%)\n\nFlock input table 3:\nEnter an FCR value. The target value is the average from the performance data. The difference betwene these will be calculated and used to update the performance data.  If the FCR value is not known, this can be left blank and the target value will be used.\nEnter a value for the bodyweight at clear. The target value is from the performance data. The difference between these will be calculated and used to adjust the performance data. \n\nFlock input table 4:\nEnter a percentage value for 7 day mortality in the white box."]
[null,"Per Shed/Farm"]
[null,"Number of birds per cycle"]
[null,"Days empty between cycles"]
[null,"Number of cycles per year",{"$f":"IF(C13=\"\",\"\",IF(C6=\"\",\"\",(365/((C13*7)+C6))))","v":""}]
[]
[null,"Flock input table 2: "]
[null,"Flock Program Summary","Week","Percentage of flock"]
[null,"Age of 1st thin",null,"% 1st thin"]
[null,"Age of 2nd thin",null,"% 2nd thin"]
[null,"Age of clear",null,"% clear"]
[null,null,null,null,{"$f":"SUM(E11:E13)","v":0}]
[]
[null,"Flock input table 3:"]
[null,"Modelling Factors","Your Values","Target Value"]
[null,"FCR",null,{"$f":"AVERAGE(Table2[FC (kg/kg)])","v":1.5757142857142856}]
[null,"Bodyweight (g)",null,{"$f":"VLOOKUP(C13,Perf_Data,3)","v":0}]
[]
[null,"Flock input table 4:"]
[null,"Other Factors"]
[null,"7 day mortality (% of flock)"]
[]
[]
[null,null,null,null,null,null,"Performance data available here."]

{"sheet":"Diet input details","index":2,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":false,"merged":[[18,1,18,2],[3,7,21,11],[17,1,17,5],[3,1,3,4],[14,1,14,2],[4,1,4,2]]}
[null,null,null,null,"Input data - diet details"]
[]
[null,"Diet input table 1:"]
[null,"Diet Details",null,null,null,null,null,"\nFlock details input instructions\n\nDiet input table 1:\nPlease input protein levels (values can be found on all feed declaration tickets) for the appropriate diets in the white boxes in the \"Diet Details\" table.\nIf the diets are the same (e.g. Grower 1 and 2), then please put the same protein and phosphorus values in both respective sets of boxes\nIf feed diet groups are not used then leave the cells blank and move on to the next used group. There is a separate row for composition of Whole Wheat. If Whole Wheat is not fed these cells can be left blank.\nEditable entry cells can be used to add a description/name to the feed rations you use.\n\n\nDiet input table 2:\nEnter the start and end days within the production cycle for each diet including the proportion( percentage of total ration fed) of the diet that is made up using whole wheat in the final column. \n"]
[null,"Diet",null,"Crude Protein (%)","Total Nitrogen (%)"]
[null,"Ration 1","Editable entry cell",null,{"$f":"D6/6.25","v":0}]
[null,"Ration 2","Editable entry cell",null,{"$f":"D7/6.25","v":0}]
[null,"Ration 3","Editable entry cell",null,0]
[null,"Ration 4","Editable entry cell",null,0]
[null,"Ration 5","Editable entry cell",null,0]
[null,"Ration 6","Editable entry cell",null,0]
[null,"Ration 7","Editable entry cell",null,0]
[null,"Ration 8","Editable entry cell",null,0]
[null,"Ration 9","Editable entry cell",null,{"$f":"D14/6.25","v":0}]
[null,"Whole Wheat",null,null,{"$f":"D15/6.25","v":0}]
[]
[null,"Diet input table 2:"]
[null,"Feed Plan Details"]
[null,"Diet",null,"Feed Start (Week)","Feed End (Week)","Whole Wheat (% of ration)"]
[null,{"$f":"B6","v":"Ration 1"},{"$f":"IF(C6=\"Editable entry cell\",\"\",IF(C6=\"\",\"\",C6))","v":""}]
[null,{"$f":"B7","v":"Ration 2"},{"$f":"IF(C7=\"Editable entry cell\",\"\",IF(C7=\"\",\"\",C7))","v":""}]
[null,"Ration 3",""]
[null,"Ration 4",""]
[null,"Ration 5",""]
[null,"Ration 6",""]
[null,"Ration 7",""]
[null,"Ration 8",""]
[null,"Ration 9",""]

{"sheet":"Results","index":3,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[[5,9,14,13],[22,4,22,5],[2,5,2,6],[23,4,23,5],[10,1,10,3],[22,2,22,3],[23,2,23,3],[2,1,2,2],[13,2,13,3],[6,1,6,3],[7,1,7,3],[21,2,21,7],[22,6,22,7],[23,6,23,7]]}
[null,null,null,null,"Export data - emission levels"]
[]
[null,"Installation name:",null,{"$f":"'Introduction and guidance'!E41","v":0},null,"Permit Number:",null,{"$f":"'Introduction and guidance'!K41","v":0}]
[]
[]
[null,"BAT Emission Level",null,null,null,null,null,null,null,"\nResults sheet instructions\n\nUse the data given in this box to demonstrate compliance with the nitrogen excretion levels.\n\nBased on the data entered within the diet and flock details input the emission levels are calculated within the BAT Emission level box, and colour coded green to show compliance with the upper limits of the BAT standards. If the cells turn red then the emission levels are not compliant\n\n   -  Nitrogen upper limit = 0.8kg N/animal/place/year\n\n"]
[null,"Nitrogen excreted\nPer animal place (kg N/ Year)"]
[null,{"$f":"G19","v":{"$error":"#VALUE!"}}]
[]
[null,"Percentage of BAT upper Limit"]
[null,{"$f":"B8/0.6","v":{"$error":"#VALUE!"}}]
[]
[]
[null,null,"Intake Data",null,null,null,"Emission Data"]
[null,null,"Cumulative feed intake (t)","Nitrogen intake (t)",null,null,"Nitrogen excreted (t)"]
[null,"Per cycle",{"$f":"'Calculations - Dataset'!B118","v":0},{"$f":"'Calculations - Dataset'!C118","v":0},null,"Per cycle",{"$f":"'Calculations - Dataset'!D118","v":0}]
[null,"Per year",{"$f":"'Calculations - Dataset'!B119","v":{"$error":"#VALUE!"}},{"$f":"'Calculations - Dataset'!C119","v":{"$error":"#VALUE!"}},null,"Per year",{"$f":"'Calculations - Dataset'!D119","v":{"$error":"#VALUE!"}}]
[null,null,"Cumulative feed intake (kg)","Nitrogen intake (kg)",null,null,"Nitrogen excreted (kg)"]
[null,"Per animal place/year",{"$f":"'Calculations - Dataset'!B120","v":{"$error":"#VALUE!"}},{"$f":"'Calculations - Dataset'!C120","v":{"$error":"#VALUE!"}},null,"Per animal place/year",{"$f":"'Calculations - Dataset'!A110","v":{"$error":"#VALUE!"}}]
[]
[]
[null,null,"Emission Levels"]
[null,null,"Per cycle (t)",null,"Per year (t)",null,"kg per Tonne liveweight"]
[null,"Nitrogen",{"$f":"G16","v":0},null,{"$f":"G17","v":{"$error":"#VALUE!"}},null,{"$f":"((C24*1000)/('Calculations - Dataset'!$B$138/1000))","v":{"$error":"#DIV/0!"}}]

{"sheet":"References and assumptions log","index":4,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["References and assumptions log"]
[]
["Unique ID","Description with key details ","Location in workbook","Link to evidence","Date of last update","Initials","Methodology behind assumption","Assumptions","Any other comments","Reference or assumption"]
["Poultry 01","This table presents performance data on ducks form Lohmann International",{"$f":"CELL(\"address\",'Calculations - Data tables'!B4)","v":"'[Duck_Model draft_V3_Password protected.xlsm]Calculations - Data tables'!$B$4"},"Performance of current Peking duck breeds - Lohmann Breeders (lohmann-breeders.com)",44977,"LR","This data has been used to pull out body weight and cumulative intake values for poultry.","The data is presented in grams per day.","Updated data tables from those previously used in the AIC models.","Reference"]
["Poultry 02","Nitrogen Conversion Factor",{"$f":"CELL(\"address\",'Calculations - Data tables'!B19)","v":"'[Duck_Model draft_V3_Password protected.xlsm]Calculations - Data tables'!$B$19"},"FAO (N.D>) https://www.fao.org/3/y5022e/y5022e03.htm#:~:text=On%20the%20basis%20of%20early,nitrogen%20content%20into%20protein%20content.",44977,"LR","This factor is used to convert crude protein content of feed to nitrogen.","Does not consider specifics of individual feeds but is a standardised factor used within the industry.","None.","Reference"]
["Poultry 03","Nitrogen Retention in Ducks",{"$f":"CELL(\"address\",'Calculations - Data tables'!B27)","v":"'[Duck_Model draft_V3_Password protected.xlsm]Calculations - Data tables'!$B$27"},"Defra_WT1568_14860_WT1568WorkPackage6. (1).pdf",44978,"LR","This data has been used to calculate the impact of including phytase in the diet on the excretion of phosphorus.","Previously referenced in the AIC duck model.","Data limitation - This data is taken from a South American paper, and the diet is based on corn and soybean, on only 38-42d old ducks in a full metabolism trial.","Reference"]
["None","Phytase feed additives effect on nitrogen","None","None",44978,"LR","None","Within the model calculations nitrogen is not impacted by phytase, this is an assumption based on current literature. ","This can be updated in the model a link is found.","Assumption"]
["None","N and P retention factors","None","None",44978,"LR","None","The N and P retention factors do not require editing by user - the factors used in this model are from Assuena et al. (2009) ","This can be updated in the model a link is found.","Assumption"]
["None","Liveweight data","None","None",44978,"LR","None","We have included weighted average and liveweight to the dataset page as these are not required to be updated by the input user.","None","Assumption"]
["None","duck performance data","None","None",44978,"LR","None","Currently the duck performance data is based on \"As Hatched\" data which means it is a combination of both sexes.","None","Assumption"]

{"sheet":"Calculations - Data tables","index":5,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
["Data tables holding background data"]
[]
["Table 1. Poultry cumulative feed intake"]
["Source: ","Poultry 01"]
["This table presents performance data on ducks from Lohmann International"]
[]
["Week","Age","BW (g)","Feed intake (g)","FC (kg/kg)"]
[0,0,0]
[1,7,257,225,1.0900000000000001]
[2,14,758,813,1.1499999999999999]
[3,21,1393,1890,1.41]
[4,28,2132,3345,1.6]
[5,36,3055,5409,1.8]
[5.5,40,3442,6637,1.95]
[6,42,3608,7215,2.0299999999999998]
[]
[]
["Table 2. Protein/Nitrogen Conversion Factor"]
["Source: ","Poultry 02"]
["Factor to convert crude protein content to nitrogen content. E.g. g protein in the feed per g N in the feed."]
[]
["Protein to nitrogen conversion factor:"]
[6.25]
[]
[]
["Table 3. Nitrogen Retention Factor"]
["Source: ","Poultry 03"]
["Nitrogen retention factor"]
[]
["Nitrogen retention factor"]
[2.7199999999999998E-2]

{"sheet":"Calculations - Dataset","index":6,"n_rows":153,"n_cols":9,"rows_kept":153,"cut":false,"hidden":true,"merged":[]}
["Calculations"]
[]
["Table 1. Bodyweight and Cumulative feed intake"]
["Source: ","Poultry 01"]
["This table contains the assumed bodyweights and cumulative feed intake for the animals based on the ROSS308 performance objectives and the end day of each phase"]
[]
["Diet type","Bodyweight (g)","Cum. feed intake (g) ","FCR","Cum. Feed intake (g) (adjusted for FCR and 7 Day mort)","Wholewheat intake (%)","Compound feed intake (%)","Wholewheat intake (g)","Compound feed intake (g)"]
[{"$f":"'Diet input details'!C20","v":""},{"$f":"VLOOKUP('Diet input details'!E20,Perf_Data,3)*($A$146)","v":0},{"$f":"VLOOKUP('Diet input details'!E20,Perf_Data,4)","v":0},{"$f":"IF('Flock input details'!$C$18>0,VLOOKUP('Diet input details'!E20,Perf_Data,5)*($A$153),VLOOKUP('Diet input details'!E20,Perf_Data,5))","v":0},{"$f":"Table1_bw_feed_intake[[#This Row],[Bodyweight (g)]]*(Table1_bw_feed_intake[[#This Row],[FCR]])*(1-'Flock input details'!$C$23)","v":0},{"$f":"'Diet input details'!F20","v":0},{"$f":"1-F8","v":1},{"$f":"F8*E8","v":0},{"$f":"IF(Table1_bw_feed_intake[[#This Row],[Cum. Feed intake (g) (adjusted for FCR and 7 Day mort)]]>0,G8*E8,0)","v":0}]
[{"$f":"'Diet input details'!C21","v":""},{"$f":"VLOOKUP('Diet input details'!E21,Perf_Data,3)*($A$146)","v":0},{"$f":"VLOOKUP('Diet input details'!E21,Perf_Data,4)","v":0},{"$f":"IF('Flock input details'!$C$18>0,VLOOKUP('Diet input details'!E21,Perf_Data,5)*($A$153),VLOOKUP('Diet input details'!E21,Perf_Data,5))","v":0},{"$f":"Table1_bw_feed_intake[[#This Row],[Bodyweight (g)]]*(Table1_bw_feed_intake[[#This Row],[FCR]])*(1-'Flock input details'!$C$23)","v":0},{"$f":"'Diet input details'!F21","v":0},{"$f":"1-F9","v":1},{"$f":"F9*(E9-E8)","v":0},{"$f":"IF(Table1_bw_feed_intake[[#This Row],[Cum. Feed intake (g) (adjusted for FCR and 7 Day mort)]]>0,G9*(E9-E8),0)","v":0}]
[{"$f":"'Diet input details'!C22","v":""},{"$f":"VLOOKUP('Diet input details'!E22,Perf_Data,3)*($A$146)","v":0},{"$f":"VLOOKUP('Diet input details'!E22,Perf_Data,4)","v":0},{"$f":"IF('Flock input details'!$C$18>0,VLOOKUP('Diet input details'!E22,Perf_Data,5)*($A$153),VLOOKUP('Diet input details'!E22,Perf_Data,5))","v":0},{"$f":"Table1_bw_feed_intake[[#This Row],[Bodyweight (g)]]*(Table1_bw_feed_intake[[#This Row],[FCR]])*(1-'Flock input details'!$C$23)","v":0},{"$f":"'Diet input details'!F22","v":0},1,0,{"$f":"IF(Table1_bw_feed_intake[[#This Row],[Cum. Feed intake (g) (adjusted for FCR and 7 Day mort)]]>0,G10*(E10-E9),0)","v":0}]
[{"$f":"'Diet input details'!C23","v":""},{"$f":"VLOOKUP('Diet input details'!E23,Perf_Data,3)*($A$146)","v":0},{"$f":"VLOOKUP('Diet input details'!E23,Perf_Data,4)","v":0},{"$f":"IF('Flock input details'!$C$18>0,VLOOKUP('Diet input details'!E23,Perf_Data,5)*($A$153),VLOOKUP('Diet input details'!E23,Perf_Data,5))","v":0},{"$f":"Table1_bw_feed_intake[[#This Row],[Bodyweight (g)]]*(Table1_bw_feed_intake[[#This Row],[FCR]])*(1-'Flock input details'!$C$23)","v":0},{"$f":"'Diet input details'!F23","v":0},1,0,{"$f":"IF(Table1_bw_feed_intake[[#This Row],[Cum. Feed intake (g) (adjusted for FCR and 7 Day mort)]]>0,G11*(E11-E10),0)","v":0}]
[{"$f":"'Diet input details'!C24","v":""},{"$f":"VLOOKUP('Diet input details'!E24,Perf_Data,3)*($A$146)","v":0},{"$f":"VLOOKUP('Diet input details'!E24,Perf_Data,4)","v":0},{"$f":"IF('Flock input details'!$C$18>0,VLOOKUP('Diet input details'!E24,Perf_Data,5)*($A$153),VLOOKUP('Diet input details'!E24,Perf_Data,5))","v":0},{"$f":"Table1_bw_feed_intake[[#This Row],[Bodyweight (g)]]*(Table1_bw_feed_intake[[#This Row],[FCR]])*(1-'Flock input details'!$C$23)","v":0},{"$f":"'Diet input details'!F24","v":0},1,0,{"$f":"IF(Table1_bw_feed_intake[[#This Row],[Cum. Feed intake (g) (adjusted for FCR and 7 Day mort)]]>0,G12*(E12-E11),0)","v":0}]
[{"$f":"'Diet input details'!C25","v":""},{"$f":"VLOOKUP('Diet input details'!E25,Perf_Data,3)*($A$146)","v":0},{"$f":"VLOOKUP('Diet input details'!E25,Perf_Data,4)","v":0},{"$f":"IF('Flock input details'!$C$18>0,VLOOKUP('Diet input details'!E25,Perf_Data,5)*($A$153),VLOOKUP('Diet input details'!E25,Perf_Data,5))","v":0},{"$f":"Table1_bw_feed_intake[[#This Row],[Bodyweight (g)]]*(Table1_bw_feed_intake[[#This Row],[FCR]])*(1-'Flock input details'!$C$23)","v":0},{"$f":"'Diet input details'!F25","v":0},1,0,{"$f":"IF(Table1_bw_feed_intake[[#This Row],[Cum. Feed intake (g) (adjusted for FCR and 7 Day mort)]]>0,G13*(E13-E12),0)","v":0}]
[{"$f":"'Diet input details'!C26","v":""},{"$f":"VLOOKUP('Diet input details'!E26,Perf_Data,3)*($A$146)","v":0},{"$f":"VLOOKUP('Diet input details'!E26,Perf_Data,4)","v":0},{"$f":"IF('Flock input details'!$C$18>0,VLOOKUP('Diet input details'!E26,Perf_Data,5)*($A$153),VLOOKUP('Diet input details'!E26,Perf_Data,5))","v":0},{"$f":"Table1_bw_feed_intake[[#This Row],[Bodyweight (g)]]*(Table1_bw_feed_intake[[#This Row],[FCR]])*(1-'Flock input details'!$C$23)","v":0},{"$f":"'Diet input details'!F26","v":0},1,0,{"$f":"IF(Table1_bw_feed_intake[[#This Row],[Cum. Feed intake (g) (adjusted for FCR and 7 Day mort)]]>0,G14*(E14-E13),0)","v":0}]
[{"$f":"'Diet input details'!C27","v":""},{"$f":"VLOOKUP('Diet input details'!E27,Perf_Data,3)*($A$146)","v":0},{"$f":"VLOOKUP('Diet input details'!E27,Perf_Data,4)","v":0},{"$f":"IF('Flock input details'!$C$18>0,VLOOKUP('Diet input details'!E27,Perf_Data,5)*($A$153),VLOOKUP('Diet input details'!E27,Perf_Data,5))","v":0},{"$f":"Table1_bw_feed_intake[[#This Row],[Bodyweight (g)]]*(Table1_bw_feed_intake[[#This Row],[FCR]])*(1-'Flock input details'!$C$23)","v":0},{"$f":"'Diet input details'!F27","v":0},1,0,{"$f":"IF(Table1_bw_feed_intake[[#This Row],[Cum. Feed intake (g) (adjusted for FCR and 7 Day mort)]]>0,G15*(E15-E14),0)","v":0}]
[{"$f":"'Diet input details'!C28","v":""},{"$f":"VLOOKUP('Diet input details'!E28,Perf_Data,3)*($A$146)","v":0},{"$f":"VLOOKUP('Diet input details'!E28,Perf_Data,4)","v":0},{"$f":"IF('Flock input details'!$C$18>0,VLOOKUP('Diet input details'!E28,Perf_Data,5)*($A$153),VLOOKUP('Diet input details'!E28,Perf_Data,5))","v":0},{"$f":"Table1_bw_feed_intake[[#This Row],[Bodyweight (g)]]*(Table1_bw_feed_intake[[#This Row],[FCR]])*(1-'Flock input details'!$C$23)","v":0},{"$f":"'Diet input details'!F28","v":0},1,0,{"$f":"IF(Table1_bw_feed_intake[[#This Row],[Cum. Feed intake (g) (adjusted for FCR and 7 Day mort)]]>0,G16*(E16-E15),0)","v":0}]
["Total",{"$f":"SUMIF(B8:B16,\"<>#N/A\")","v":0},{"$f":"SUMIF(C8:C16,\"<>#N/A\")","v":0},null,null,null,null,{"$f":"SUMIF(H8:H16,\"<>#N/A\")","v":0},{"$f":"SUMIF(I8:I16,\"<>#N/A\")","v":0}]
[]
[]
["Table 2. N and P Intake"]
["Source: ","N/A"]
["This table contains the N and P intake at each phase based on the cumulative feed intake (Table 1 from 'Data tables'), and the nutrient status of the feed (from 'Diet input details')"]
[]
["Diet type","Feed Nitrogen conc. (%)","Wholewheat Nitrogen conc. (%) ","Compound Feed Nitrogen consumed (g)","Wholewheat Nitrogen consumed (g)","Total Nitrogen consumed (g)"]
[{"$f":"A8","v":""},{"$f":"'Diet input details'!D6/'Calculations - Data tables'!$A$23","v":0},{"$f":"'Diet input details'!$E$15","v":0},{"$f":"B25%*I8","v":0},{"$f":"C25%*H8","v":0},{"$f":"D25+E25","v":0}]
[{"$f":"A9","v":""},{"$f":"'Diet input details'!D7/'Calculations - Data tables'!$A$23","v":0},{"$f":"'Diet input details'!$E$15","v":0},0,0,0]
["",{"$f":"'Diet input details'!D8/'Calculations - Data tables'!$A$23","v":0},{"$f":"'Diet input details'!$E$15","v":0},0,0,0]
["",{"$f":"'Diet input details'!D9/'Calculations - Data tables'!$A$23","v":0},{"$f":"'Diet input details'!$E$15","v":0},0,0,0]
["",{"$f":"'Diet input details'!D10/'Calculations - Data tables'!$A$23","v":0},{"$f":"'Diet input details'!$E$15","v":0},0,0,0]
["",{"$f":"'Diet input details'!D11/'Calculations - Data tables'!$A$23","v":0},{"$f":"'Diet input details'!$E$15","v":0},0,0,0]
["",{"$f":"'Diet input details'!D12/'Calculations - Data tables'!$A$23","v":0},{"$f":"'Diet input details'!$E$15","v":0},0,0,0]
["",{"$f":"'Diet input details'!D13/'Calculations - Data tables'!$A$23","v":0},{"$f":"'Diet input details'!$E$15","v":0},0,0,0]
["",{"$f":"'Diet input details'!D14/'Calculations - Data tables'!$A$23","v":0},{"$f":"'Diet input details'!$E$15","v":0},0,0,0]
["Total ",null,null,{"$f":"SUMIF(D25:D33,\"<>#N/A\")","v":0},{"$f":"SUMIF(E25:E33,\"<>#N/A\")","v":0},0]
[]
[]
[]
["Table 4. Retention Factor"]
["Source: ","Poultry 03","Defra_WT1568_14860_WT1568WorkPackage6. (1).pdf"]
["Presents the N retention factor that will be used based on the level of phytase inclusion in diet from the 'Flock input details'"]
[]
[]
[null,"N retention factor"]
[null,2.72]
[]
[]
["Table 5. N and P Retained "]
["Source: ","Table 2/Table 4 from 'Dataset'"]
["This table shows the amount of N and P that is retained in the body weight of the animal "]
[]
["Diet type","Nitrogen retained (g)"]
[{"$f":"A25","v":""},{"$f":"IF(B8>0,B8*($B$44/100),0)","v":0}]
[{"$f":"A26","v":""},{"$f":"IF(B9>0,(B9-B8)*($B$44/100),0)","v":0}]
["",{"$f":"IF(B10>0,(B10-B9)*($B$44/100),0)","v":0}]
["",{"$f":"IF(B11>0,(B11-B10)*($B$44/100),0)","v":0}]
["",0]
["",0]
["",0]
["",0]
["",0]
[]
["Table 6. N and P excreted"]
["Source: ","Table 2/Table 4 from 'Dataset'"]
["N and P ingested (Table 2) take away N and P retained (Table 4)"]
[]
["Diet type","Nitrogen excreted (g)"]
[{"$f":"A52","v":""},{"$f":"F25-B52","v":0}]
[{"$f":"A53","v":""},{"$f":"F26-B53","v":0}]
["",0]
["",{"$f":"F28-B55","v":0}]
["",0]
["",0]
["",0]
["",0]
["",0]
[]
["Table 7. Thinning Values"]
["Source: ","Flock input details' "]
["This table presents the thinning factors that can be used to adjust the excretion values from Table 5"]
[]
[null,"Thinning %","Thinning value"]
[null,{"$f":"'Flock input details'!E11","v":0},{"$f":"B82","v":0}]
[null,{"$f":"'Flock input details'!E12","v":0},{"$f":"IF(B83>0,B83,B84)","v":0}]
[null,{"$f":"'Flock input details'!E13","v":0},{"$f":"IF(B83>0,B84,0)","v":0}]
["100% check ",{"$f":"SUM(B82:B84)=100%","v":false},{"$f":"SUM(C82:C84)=100%","v":false}]
[]
[]
["Table 8. Thinned Excretion Values"]
["Source: ","Table 6/Table 7"]
["This table presents the N and P excretion from Table 6, adjusted to reflect the amount of birds thinned using the thinning value in Table 7"]
[]
["Diet type","Nitrogen Excreted (g)"]
[{"$f":"A67","v":""},{"$f":"B67","v":0}]
[{"$f":"A68","v":""},0]
["",{"$f":"B69","v":0}]
["",{"$f":"B70","v":0}]
["",0]
["",{"$f":"B72*$C$83","v":0}]
["",{"$f":"B73*$C$83","v":0}]
["",{"$f":"B74*$C$83","v":0}]
["",0]
["TOTAL",{"$f":"SUMIF(B93:B101,\"<>#N/A\")","v":0}]
[]
[]
["Table 9. Nutrient excretion (kg/animal place/year)"]
["Source: "]
["This table converts the excretion values presented in Table 8 from grams per bird to kg/animal place/year.  The total nutrient excreted (from Table 8) is multiplied by cycles per year (from 'Flock input details'), and then divided by 1000 to convert from g to kg"]
[]
["Nitrogen excretion (kg/animal place/year)"]
[{"$f":"(B102*'Flock input details'!C7)/1000","v":{"$error":"#VALUE!"}}]
[]
[]
["Table 10. Per cycle/Per year values "]
["Source: ","N/A"]
["This table presents the intake and excreted values on a per cycle and per basis .  These values are based off what has been calculated in the tables above and the days input to 'Flock input details'"]
[]
["Per cycle/year","Feed Intake (g)","Nitrogen Intake (g)","Nitrogen Excretion (g)"]
["Per cycle",{"$f":"(I17*'Flock input details'!C5)/1000000","v":0},{"$f":"(F34*'Flock input details'!C5)/1000000","v":0},{"$f":"(B102*'Flock input details'!C5)/1000000","v":0}]
["Per year",{"$f":"B118*'Flock input details'!C7","v":{"$error":"#VALUE!"}},{"$f":"C118*'Flock input details'!C7","v":{"$error":"#VALUE!"}},{"$f":"D118*'Flock input details'!C7","v":{"$error":"#VALUE!"}}]
["Per animal place/per year",{"$f":"(I17*'Flock input details'!C7)/1000","v":{"$error":"#VALUE!"}},{"$f":"(F34*'Flock input details'!C7)/1000","v":{"$error":"#VALUE!"}}]
[]
["Table 11. Weighted Avg. Bird Weight"]
["Source: ","N/A"]
["This calculates the  weighted average bird weight based on bodyweight from ROSS308, %  thinned, and days of age data"]
[]
["Thinning","Bodyweight after thins (g)","Bodyweight after mortality (g)","Bodyweight after chick mortality (g)"]
["1 thin",{"$f":"(VLOOKUP('Flock input details'!C11,Perf_Data,3,FALSE)*'Flock input details'!E11)+(VLOOKUP('Flock input details'!C13,Perf_Data,3,FALSE)*'Flock input details'!E13)","v":0},{"$f":"B127*(1-'Flock input details'!$C$23)","v":0},{"$f":"C127-($B$8*'Flock input details'!$C$23)","v":0}]
["2 thins",{"$f":"(VLOOKUP('Flock input details'!C11,Perf_Data,3,FALSE)*'Flock input details'!E11)+(VLOOKUP('Flock input details'!C12,Perf_Data,3,FALSE)*'Flock input details'!E12)+(VLOOKUP('Flock input details'!C13,Perf_Data,3,FALSE)*'Flock input details'!E13)","v":0},{"$f":"B128*(1-'Flock input details'!$C$23)","v":0},{"$f":"C128-($B$8*'Flock input details'!$C$23)","v":0}]
[]
[]
["Table 12. Liveweight Calcs"]
["Source: ","N/A"]
["This calculates the  weighted average bird weight based on bodyweight from ROSS308, %  thinned, and days of age data"]
[]
[]
["Weight group","kg"]
["Weighted Ave. Bird weight (kg)",{"$f":"(IF('Flock input details'!C12>0,'Calculations - Dataset'!D128,'Calculations - Dataset'!D127))/1000*Table5[% of Target bodyweight]","v":0}]
["Liveweight/Crop (kg)",{"$f":"B137*('Flock input details'!C5*(1-'Flock input details'!C23))","v":0}]
[]
[]
["Table 13. Bodyweight Adjustment"]
["Source: ","N/A"]
["This calculates the % of the target bodyweight that the average bird in the system is reaching at clear"]
[]
["% of Target bodyweight"]
[{"$f":"IF('Flock input details'!C19>0,'Flock input details'!C19/'Flock input details'!D19,1)","v":1}]
[]
["Table 14. FCR Adjustment"]
["Source: ","N/A"]
["This calculates the % of the target bodyweight that the average bird in the system is reaching at clear"]
[]
["% of Reference FCR"]
[{"$f":"'Flock input details'!C18/'Flock input details'!D18","v":0}]